Data Preparation for USAspending Explorer App

New York as an exmaple

Scrap County Codes

Scrap State Population Data (Wikipedia)

Merge State Population Data and State County Code

Request the USAspending API and Pagination

Merge Population_County_Code with County Grants Data

Data Vis for USAspending Explorer App

The First Result

The Second Result

The Third Result

Request the USAspending API

The End